Identifies the data source name, such as Payroll or Personnel. When the Microsoft Excel 3.0 or 4.0 driver is used, specifies the default data directory in which the ODBC driver searches for data files. For Microsoft Excel 5.0, 7.0, or 97, specifies the default data workbook in which the ODBC driver searches for data files.
.topic 4
An optional description of the data in the data source; for example, "Hire date, salary history, and current employees' reviews."
.topic 5
Displays Help for this dialog box.
.topic 6
Exits the Setup dialog box and saves changes.
.topic 7
Select to make the database read-only to prohibit any updates.
.topic 8
The number of rows to scan to determine the data type of each column. For the Microsoft Excel driver, this can be any number from 1 to 16, defaulting to 8; if set to 0, all rows are scanned.
.topic 9
Click to open the Select Directory dialog box, where you can select a directory containing the files you want to access. When defining a data source directory, specify the directory that contains your most commonly used Excel files for Microsoft Excel 3.0 or 4.0.
.topic 10
Click to open the Select Workbook dialog box, where you can select a workbook you want to access.
.topic 11
Select to make the application's current working directory the data source directory. When cleared, you can select the data source directory by clicking the Select Directory button. Disabled for Microsoft Excel 5.0, 7.0, and 97.
.topic 12
Specifies the Excel version of the files used.
.topic 13
Use these options to change the location and version of Excel files.
.topic 14
Use these options to configure driver-specific attributes.
.topic 15
Click to configure driver-specific attributes.
.topic 16
The location of the selected Excel directory.
.topic 17
The location of the selected Excel workbook.
.topic 201
Click to add an extension that has been typed in the Extension box.
.topic 202
Exits this dialog box without saving any changes.
.topic 203
Identifies the data source name, such as Payroll or Personnel, and specifies the default data directory in which the ODBC driver searches for data files.
.topic 204
When selected, all files in the directory can be used. When cleared, the Extensions List defaults to *.asc, *.csv, *.tab, and *.txt extensions, and you can add or delete specific extensions as desired.
.topic 205
Click to open the Define Text Format dialog box, where you can define column formats and specify table schemas in the data source directory.
.topic 206
An optional description of the data in the data source; for example, "Hire date, salary history, and current employees' reviews."
.topic 207
Enter the file extension you want to add, using the format *.xxx. For example, to use .dat files, type the extension *.dat.
.topic 208
Lists the file name extensions of the text files in the data source, based on the selected or cleared status of the Default check box.
.topic 214
Use these options to format specific file types.
.topic 215
Use these options to add or remove nondefault file extensions from the Extensions List. To add a file extension, clear the Default check box, type the new extension in the Extension box, and click Add.
.topic 216
Use these options to select the location of the text file and display the file name.
.topic 209
Displays Help for this dialog box.
.topic 210
Exits the Setup dialog box and saves changes.
.topic 211
Click to remove a selected file extension from the Extensions List.
.topic 212
Click to open the Select Directory dialog box, where you can select a directory containing the files you want to access.
.topic 213
Select to make the application's current working directory the data source directory. When cleared, you can select the data source directory by clicking Select Directory.
.topic 217
Click to configure text file attributes and add or remove text file types.
.topic 218
Identifies the location of the text file.
.topic 301
Click to add a column using the values in the Data Type, Name, and Width fields.
.topic 302
Exits this dialog box without saving any changes.
.topic 321
Specifies a character set as either ANSI or OEM.
.topic 303
Specifies a character set as ANSI for the format of the item selected in the Tables list.
.topic 304
Specifies whether the columns of the selected table's first row will be used as column names (TRUE if selected, FALSE if cleared).
.topic 305
Lists the column names for each column in the table selected in the Tables list and reflects the order of the columns in the table.
.topic 319
Allows you to define column attributes for the selected text file.
.topic 306
Displays the data type and can be BIT, BYTE, CHAR, CURRENCY, DATE, FLOAT, INTEGER, LONGCHAR, SHORT, or SINGLE.
.topic 307
The custom delimiter character to be used to separate columns. Must be only one character in length, and double quotation marks (") cannot be used. Enabled when Custom Delimited is selected from the Format list box.
.topic 308
Either delimited or fixed-length; if delimited, indicates the type of delimiter used.
.topic 309
Generates the data type, name, and width values for the columns in the selected table by scanning the table's contents according to the Format list box selection. Enabled when the table format is delimited.
.topic 310
Displays Help for this dialog box.
.topic 311
Modifies the selected column using the values in the Data Type, Name, and Width fields.
.topic 312
Displays the name of the selected column. Can be used to specify a new column name for either an existing column or a new column.
.topic 313
Exits this dialog box and saves changes.
.topic 314
Deletes the selected column.
.topic 315
The number of rows that Setup or the driver will scan when setting the columns and column data types. Defaults to 25 if the format of the item selected in the Tables list has not been defined, but can be any number from 1 to 32767.
.topic 316
Lists all files that match the list of extensions specified in the ODBC Text Setup dialog box. Select a file to display or modify its table attributes.
.topic 320
Use these options to define table attributes for a selected text file.
.topic 317
The width of the column; can be changed for CHAR or LONGCHAR columns. For other data types, Width is disabled and no value is displayed. Defaults to 1 if the format of the item selected in the Tables list has not been defined.
.topic 318
Specifies a non-ANSI character set (the default) for the format of the file selected in the Tables list.
.topic 401
Exits this dialog box without saving any changes.
.topic 402
The sequence -- whether ASCII (the default), International, Swedish-Finnish, or Norwegian-Danish -- in which the fields are sorted.
.topic 403
Identifies the data source name, such as Payroll or Personnel, and specifies the default data directory in which the ODBC driver searches for data files.
.topic 404
An optional description of the data in the data source; for example, "Hire date, salary history, and current employees' reviews."
.topic 405
When selected, the database opens in Exclusive mode, which limits access to one user at a time and improves performance. When cleared, the database opens in Shared mode and can be accessed simultaneously by multiple users.
.topic 406
Displays Help for this dialog box.
.topic 407
Specifies the network access style to use when accessing Paradox data: either "3.x" for Paradox 3.x or "4.x" for Paradox 4.x or 5.x. Can be set to either "3.x" or "4.x" for Paradox versions 4.x and 5.x; for Paradox version 3.x, the style must be "3.x".
.topic 408
Exits the Setup dialog box and saves changes.
.topic 409
The period of time, in tenths of a second, that an unused page remains in the buffer. The default value is 600 tenths (or 60 seconds) and must be greater than 0.
.topic 410
Click to open the Select Directory dialog box, where you can select a directory containing the files you want to access.
.topic 415
Identifies the location of the Paradox file.
.topic 411
Before selecting a network directory, you must enter your Paradox user name in the User Name text box. Then click Select Network Directory to select a network directory.
.topic 416
The path of the directory containing a Paradox lock database and also containing either the Pdoxusrs.net file (in Paradox 4.x) or the Paradox.net file (in Paradox 5.x). If the directory does not contain one of these files, the Paradox driver creates one.
.topic 412
Select to make the application's current working directory the data source directory. When cleared, you can select the data source directory by clicking Select Directory.
.topic 413
The Paradox user name displayed to other users of Paradox files when a lock is encountered.
.topic 414
Specifies the Paradox version of the files used -- for example, Paradox 4.x or Paradox 5.x.
.topic 417
Use these options to select and display the version and location of the Paradox database.
.topic 418
Use these options to configure the Paradox driver.
.topic 419
Click to configure driver-specific attributes.
.topic 501
Specifies whether table-size statistics are approximated. This option applies to all data sources that use the dBASE driver.
.topic 502
Exits this dialog box without saving any changes.
.topic 503
The sequence, either ASCII (the default) or international selections, in which the fields are sorted.
.topic 504
Identifies the data source name, such as Payroll or Personnel, and specifies the default data directory in which the ODBC driver searches for data files.
.topic 505
An optional description of the data in the data source; for example, "Hire date, salary history, and current employees' reviews."
.topic 506
When selected, the database opens in Exclusive mode, which limits access to one user at a time and improves performance. When cleared, the database opens in Shared mode and can be accessed simultaneously by multiple users.
.topic 507
Displays Help for this dialog box.
.topic 508
Exits the Setup dialog box and saves changes.
.topic 509
The period of time, in tenths of a second, that an unused page remains in the buffer. The default value is 600 tenths (or 60 seconds) and must always be greater than 0.
.topic 515
Identifies the location of the dBASE database.
.topic 510
Click to open the Select Directory dialog box, where you can select a directory containing the files you want to access.
.topic 511
Click to open the Select Indexes dialog box, where you can associate dBASE files with index files.
.topic 512
Specifies whether rows marked as deleted can be retrieved or positioned on. If cleared (the default), deleted rows are not displayed; if selected, deleted rows are treated the same as undeleted rows.
.topic 513
Select to make the application's current working directory the data source directory. When cleared, you can select the data source directory by clicking Select Directory.
.topic 514
Specifies the version of the dBASE files used; for example, dBASE III, dBASE IV, or dBASE 5.0.
.topic 516
Use these options to select and display the version and location of the dBASE database.
.topic 517
Use these options to configure the dBASE driver.
.topic 518
Click to configure driver-specific attributes.
.topic 701
Click to set advanced driver options to alter performance.
.topic 702
The size of the internal buffer, in kilobytes, used by Microsoft Access to transfer data to and from the disk. The default is 2048 KB (displayed as 2048). Enter any integer value divisible by 256.
.topic 703
Exits this dialog box without saving any changes.
.topic 704
Click to create an Access database.
.topic 705
Click to reduce wasted space in an existing Access database.
.topic 706
Identifies the data source name, such as Payroll or Personnel, and specifies the default data directory in which the ODBC driver searches for data files.
.topic 707
The location of the currently selected Access database. To select a database, click Select.
.topic 708
An optional description of the data in the data source; for example, "Hire date, salary history, and current employees' reviews."
.topic 709
When selected, the database opens in Exclusive mode, which limits access to one user at a time and improves performance. When cleared, the database opens in Shared mode and can be accessed simultaneously by multiple users.
.topic 710
Displays Help for this dialog box.
.topic 711
If no system database will be used, select this option to log in as the Admin (DefaultUser) user for a specific Access database.
.topic 712
Exits the Setup dialog box and saves changes.
.topic 713
The period of time, in tenths of a second, that an unused page remains in the buffer. The default value is 0.5 seconds and must always be greater than 0.
.topic 714
Select to make the database read-only to prohibit any updates.
.topic 715
Click to repair a damaged Access database.
.topic 716
Click to select a specific Access database.
.topic 723
Select to use a system database. Then click System Database.
.topic 717
Click to open the Select System Database dialog box, where you can select the system (workgroup) database you want to use.
.topic 718
Use these options to view the location of the Access database and perform database maintenance functions.
.topic 719
Use these options to select a system (workgroup) database and view its location.
.topic 720
The location of the currently selected Access database.
